﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="tpShow.aspx.cs" Inherits="tpShow" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataSourceID="SqlDataSourceTp" EnableModelValidation="True" Width="503px">
    <Columns>
        <asp:BoundField DataField="tpID" HeaderText="编号" SortExpression="tpID" />
        <asp:HyperLinkField DataNavigateUrlFields="tpID" 
            DataNavigateUrlFormatString="tpView.aspx?tpID={0}" DataTextField="t_Name" 
            HeaderText="标题" />
        <asp:BoundField DataField="c_Name" HeaderText="发起人" SortExpression="c_Name" />
        <asp:BoundField DataField="t_settime" HeaderText="发布时间" 
            SortExpression="t_settime" />
    </Columns>
    <EmptyDataTemplate>
        无投票
    </EmptyDataTemplate>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSourceTp" runat="server" 
    ConnectionString="<%$ ConnectionStrings:qynbControlSystemConnectionString %>" 
    SelectCommand="SELECT tpzb.tpID, tpzb.t_Name, tpzb.t_Cus, tpzb.t_settime, tpzb.starttime, tpzb.endTime, cusInfo.c_Name FROM tpzb INNER JOIN cusInfo ON cusInfo.cusID = tpzb.t_Cus">
</asp:SqlDataSource>
</asp:Content>

